﻿
CREATE PROCEDURE [dbo].[SynchronizeCountry] ( @Rebuild BIT )
AS 
    BEGIN
        SET TRANSACTION ISOLATION LEVEL READ COMMITTED ;

        BEGIN TRANSACTION ;
        BEGIN TRY
            IF ( NOT EXISTS ( SELECT    *
                              FROM      [dbo].[Country] )
                 OR @Rebuild = 1
               ) 
                BEGIN
                    DELETE  FROM dbo.country
-- [CountryCode]=N'ad' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ad' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ad' ,
                                  N'Andorra' ,
                                  N'EUR' ,
                                  N'es' ,
                                  N'eu' ,
                                  N'ln' ,
                                  N'ad' ,
                                  N'+376' ,
                                  N'安道尔'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Andorra' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'es' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'ad' ,
                                [DialingCodes] = N'+376' ,
                                [ChineseName] = N'安道尔'
                        WHERE   [CountryCode] = N'ad'



-- [CountryCode]=N'ae' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ae' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ae' ,
                                  N'United Arab Emirates' ,
                                  N'USD' ,
                                  N'ar' ,
                                  N'me' ,
                                  N'aa' ,
                                  N'ae' ,
                                  N'+971' ,
                                  N'阿联酋'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'United Arab Emirates' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'ar' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'ae' ,
                                [DialingCodes] = N'+971' ,
                                [ChineseName] = N'阿联酋'
                        WHERE   [CountryCode] = N'ae'


-- [CountryCode]=N'af' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'af' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'af' ,
                                  N'Afghanistan' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'me' ,
                                  N'aa' ,
                                  N'af' ,
                                  N'+93' ,
                                  N'阿富汗'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Afghanistan' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'af' ,
                                [DialingCodes] = N'+93' ,
                                [ChineseName] = N'阿富汗'
                        WHERE   [CountryCode] = N'af'


-- [CountryCode]=N'ag' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ag' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ag' ,
                                  N'Antigua & Barbuda' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'ag' ,
                                  N'+1 268' ,
                                  N'安提瓜和巴布达'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Antigua & Barbuda' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'ag' ,
                                [DialingCodes] = N'+1 268' ,
                                [ChineseName] = N'安提瓜和巴布达'
                        WHERE   [CountryCode] = N'ag'


-- [CountryCode]=N'ai' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ai' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ai' ,
                                  N'Anguilla' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'ai' ,
                                  N'+1 264' ,
                                  N'安圭拉岛'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Anguilla' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'ai' ,
                                [DialingCodes] = N'+1 264' ,
                                [ChineseName] = N'安圭拉岛'
                        WHERE   [CountryCode] = N'ai'


-- [CountryCode]=N'al' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'al' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'al' ,
                                  N'Albania' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'al' ,
                                  N'+355' ,
                                  N'阿尔巴尼亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Albania' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'al' ,
                                [DialingCodes] = N'+355' ,
                                [ChineseName] = N'阿尔巴尼亚'
                        WHERE   [CountryCode] = N'al'


-- [CountryCode]=N'am' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'am' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'am' ,
                                  N'Armenia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'am' ,
                                  N'+374' ,
                                  N'亚美尼亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Armenia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'am' ,
                                [DialingCodes] = N'+374' ,
                                [ChineseName] = N'亚美尼亚'
                        WHERE   [CountryCode] = N'am'


-- [CountryCode]=N'ao' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ao' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ao' ,
                                  N'Anla' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'ao' ,
                                  N'+244' ,
                                  N'安圭拉'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Anla' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'ao' ,
                                [DialingCodes] = N'+244' ,
                                [ChineseName] = N'安圭拉'
                        WHERE   [CountryCode] = N'ao'


-- [CountryCode]=N'aq' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'aq' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'aq' ,
                                  N'Antarctica' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'aq' ,
                                  NULL ,
                                  N'南极洲'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Antarctica' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'aq' ,
                                [DialingCodes] = NULL ,
                                [ChineseName] = N'南极洲'
                        WHERE   [CountryCode] = N'aq'


-- [CountryCode]=N'ar' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ar' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ar' ,
                                  N'Argentina' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'ar' ,
                                  N'+54' ,
                                  N'阿根廷'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Argentina' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'ar' ,
                                [DialingCodes] = N'+54' ,
                                [ChineseName] = N'阿根廷'
                        WHERE   [CountryCode] = N'ar'


-- [CountryCode]=N'as' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'as' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'as' ,
                                  N'American Samoa' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'as' ,
                                  N'+1 684' ,
                                  N'美属萨摩亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'American Samoa' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'as' ,
                                [DialingCodes] = N'+1 684' ,
                                [ChineseName] = N'美属萨摩亚'
                        WHERE   [CountryCode] = N'as'


-- [CountryCode]=N'at' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'at' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'at' ,
                                  N'Austria' ,
                                  N'EUR' ,
                                  N'ge' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'at' ,
                                  N'+43' ,
                                  N'奥地利'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Austria' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'ge' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'at' ,
                                [DialingCodes] = N'+43' ,
                                [ChineseName] = N'奥地利'
                        WHERE   [CountryCode] = N'at'


-- [CountryCode]=N'au' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'au' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'au' ,
                                  N'Australia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'aa' ,
                                  N'au' ,
                                  N'+61' ,
                                  N'澳大利亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Australia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'au' ,
                                [DialingCodes] = N'+61' ,
                                [ChineseName] = N'澳大利亚'
                        WHERE   [CountryCode] = N'au'


-- [CountryCode]=N'aw' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'aw' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'aw' ,
                                  N'Aruba' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'aw' ,
                                  N'+297' ,
                                  N'阿鲁巴岛'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Aruba' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'aw' ,
                                [DialingCodes] = N'+297' ,
                                [ChineseName] = N'阿鲁巴岛'
                        WHERE   [CountryCode] = N'aw'


-- [CountryCode]=N'az' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'az' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'az' ,
                                  N'Azerbaijan' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'az' ,
                                  N'+994' ,
                                  N'阿塞拜疆'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Azerbaijan' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'az' ,
                                [DialingCodes] = N'+994' ,
                                [ChineseName] = N'阿塞拜疆'
                        WHERE   [CountryCode] = N'az'


-- [CountryCode]=N'ba' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ba' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ba' ,
                                  N'Bosnia Herzevina' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'ba' ,
                                  N'+387' ,
                                  N'波黑'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Bosnia Herzevina' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'ba' ,
                                [DialingCodes] = N'+387' ,
                                [ChineseName] = N'波黑'
                        WHERE   [CountryCode] = N'ba'


-- [CountryCode]=N'bb' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'bb' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'bb' ,
                                  N'Barbados' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'bb' ,
                                  N'+1 246' ,
                                  N'巴巴多斯'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Barbados' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'bb' ,
                                [DialingCodes] = N'+1 246' ,
                                [ChineseName] = N'巴巴多斯'
                        WHERE   [CountryCode] = N'bb'


-- [CountryCode]=N'bd' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'bd' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'bd' ,
                                  N'Bangladesh' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'bd' ,
                                  N'+880' ,
                                  N'孟加拉国'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Bangladesh' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'bd' ,
                                [DialingCodes] = N'+880' ,
                                [ChineseName] = N'孟加拉国'
                        WHERE   [CountryCode] = N'bd'


-- [CountryCode]=N'be' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'be' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'be' ,
                                  N'Belgium' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'be' ,
                                  N'+32' ,
                                  N'比利时'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Belgium' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'be' ,
                                [DialingCodes] = N'+32' ,
                                [ChineseName] = N'比利时'
                        WHERE   [CountryCode] = N'be'


-- [CountryCode]=N'bg' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'bg' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'bg' ,
                                  N'Bulgaria' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'aa' ,
                                  N'bg' ,
                                  N'+359' ,
                                  N'保加利亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Bulgaria' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'bg' ,
                                [DialingCodes] = N'+359' ,
                                [ChineseName] = N'保加利亚'
                        WHERE   [CountryCode] = N'bg'


-- [CountryCode]=N'bh' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'bh' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'bh' ,
                                  N'Bahrain' ,
                                  N'USD' ,
                                  N'ar' ,
                                  N'me' ,
                                  N'or' ,
                                  N'bh' ,
                                  N'+973' ,
                                  N'巴林'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Bahrain' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'ar' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'bh' ,
                                [DialingCodes] = N'+973' ,
                                [ChineseName] = N'巴林'
                        WHERE   [CountryCode] = N'bh'


-- [CountryCode]=N'bi' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'bi' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'bi' ,
                                  N'Burundi' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'bi' ,
                                  N'+257' ,
                                  N'布隆迪'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Burundi' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'bi' ,
                                [DialingCodes] = N'+257' ,
                                [ChineseName] = N'布隆迪'
                        WHERE   [CountryCode] = N'bi'


-- [CountryCode]=N'bj' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'bj' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'bj' ,
                                  N'Benin' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'bj' ,
                                  N'+229' ,
                                  N'贝宁'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Benin' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'bj' ,
                                [DialingCodes] = N'+229' ,
                                [ChineseName] = N'贝宁'
                        WHERE   [CountryCode] = N'bj'


-- [CountryCode]=N'bk' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'bk' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'bk' ,
                                  N'Burkina Faso' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'bk' ,
                                  N'+226' ,
                                  N'布基纳法索'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Burkina Faso' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'bk' ,
                                [DialingCodes] = N'+226' ,
                                [ChineseName] = N'布基纳法索'
                        WHERE   [CountryCode] = N'bk'


-- [CountryCode]=N'bm' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'bm' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'bm' ,
                                  N'Bermuda' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'bm' ,
                                  N'+1 441' ,
                                  N'百慕大'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Bermuda' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'bm' ,
                                [DialingCodes] = N'+1 441' ,
                                [ChineseName] = N'百慕大'
                        WHERE   [CountryCode] = N'bm'


-- [CountryCode]=N'bo' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'bo' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'bo' ,
                                  N'Bolivia' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'bo' ,
                                  N'+591' ,
                                  N'玻利维亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Bolivia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'bo' ,
                                [DialingCodes] = N'+591' ,
                                [ChineseName] = N'玻利维亚'
                        WHERE   [CountryCode] = N'bo'


-- [CountryCode]=N'br' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'br' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'br' ,
                                  N'Brazil' ,
                                  N'BRL' ,
                                  N'pt' ,
                                  N'br' ,
                                  N'br' ,
                                  N'br' ,
                                  N'+55' ,
                                  N'巴西'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Brazil' ,
                                [Currency] = N'BRL' ,
                                [DefaultLanguage] = N'pt' ,
                                [Region] = N'br' ,
                                [AccountingRegion] = N'br' ,
                                [ISOLocaleCode] = N'br' ,
                                [DialingCodes] = N'+55' ,
                                [ChineseName] = N'巴西'
                        WHERE   [CountryCode] = N'br'


-- [CountryCode]=N'bs' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'bs' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'bs' ,
                                  N'Bahamas' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'bs' ,
                                  N'+1 242' ,
                                  N'巴哈马'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Bahamas' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'bs' ,
                                [DialingCodes] = N'+1 242' ,
                                [ChineseName] = N'巴哈马'
                        WHERE   [CountryCode] = N'bs'


-- [CountryCode]=N'bt' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'bt' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'bt' ,
                                  N'Bhutan' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'bt' ,
                                  N'+975' ,
                                  N'不丹'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Bhutan' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'bt' ,
                                [DialingCodes] = N'+975' ,
                                [ChineseName] = N'不丹'
                        WHERE   [CountryCode] = N'bt'


-- [CountryCode]=N'bu' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'bu' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'bu' ,
                                  N'Brunei' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'bu' ,
                                  N'+673' ,
                                  N'文莱'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Brunei' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'bu' ,
                                [DialingCodes] = N'+673' ,
                                [ChineseName] = N'文莱'
                        WHERE   [CountryCode] = N'bu'


-- [CountryCode]=N'bw' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'bw' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'bw' ,
                                  N'Botswana' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'bw' ,
                                  N'+267' ,
                                  N'博茨瓦那'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Botswana' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'bw' ,
                                [DialingCodes] = N'+267' ,
                                [ChineseName] = N'博茨瓦那'
                        WHERE   [CountryCode] = N'bw'


-- [CountryCode]=N'by' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'by' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'by' ,
                                  N'Belarus' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'by' ,
                                  N'+375' ,
                                  N'白俄罗斯'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Belarus' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'by' ,
                                [DialingCodes] = N'+375' ,
                                [ChineseName] = N'白俄罗斯'
                        WHERE   [CountryCode] = N'by'


-- [CountryCode]=N'bz' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'bz' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'bz' ,
                                  N'Belize' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'bz' ,
                                  N'+501' ,
                                  N'伯利兹'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Belize' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'bz' ,
                                [DialingCodes] = N'+501' ,
                                [ChineseName] = N'伯利兹'
                        WHERE   [CountryCode] = N'bz'


-- [CountryCode]=N'ca' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ca' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ca' ,
                                  N'Canada' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'us' ,
                                  N'ca' ,
                                  N'+1' ,
                                  N'加拿大'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Canada' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'us' ,
                                [ISOLocaleCode] = N'ca' ,
                                [DialingCodes] = N'+1' ,
                                [ChineseName] = N'加拿大'
                        WHERE   [CountryCode] = N'ca'


-- [CountryCode]=N'cc' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'cc' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'cc' ,
                                  N'Cocos Islands' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'cc' ,
                                  N'+61 8 9162' ,
                                  N'可可群岛'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Cocos Islands' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'cc' ,
                                [DialingCodes] = N'+61 8 9162' ,
                                [ChineseName] = N'可可群岛'
                        WHERE   [CountryCode] = N'cc'


-- [CountryCode]=N'cd' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'cd' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'cd' ,
                                  N'DR Con' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'cd' ,
                                  NULL ,
                                  N'刚果民主共和国'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'DR Con' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'cd' ,
                                [DialingCodes] = NULL ,
                                [ChineseName] = N'刚果民主共和国'
                        WHERE   [CountryCode] = N'cd'


-- [CountryCode]=N'cg' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'cg' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'cg' ,
                                  N'Con' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'cg' ,
                                  N'+242, +243' ,
                                  N'刚果'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Con' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'cg' ,
                                [DialingCodes] = N'+242, +243' ,
                                [ChineseName] = N'刚果'
                        WHERE   [CountryCode] = N'cg'


-- [CountryCode]=N'ch' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ch' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ch' ,
                                  N'Switzerland' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'ch' ,
                                  N'+41' ,
                                  N'瑞士'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Switzerland' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'ch' ,
                                [DialingCodes] = N'+41' ,
                                [ChineseName] = N'瑞士'
                        WHERE   [CountryCode] = N'ch'


-- [CountryCode]=N'ci' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ci' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ci' ,
                                  N'Cote D''ivoire' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'ci' ,
                                  N'+225' ,
                                  N'科特迪瓦'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Cote D''ivoire' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'ci' ,
                                [DialingCodes] = N'+225' ,
                                [ChineseName] = N'科特迪瓦'
                        WHERE   [CountryCode] = N'ci'


-- [CountryCode]=N'ck' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ck' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ck' ,
                                  N'Cook Islands' ,
                                  N'BRL' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'ck' ,
                                  N'+682' ,
                                  N'库克群岛'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Cook Islands' ,
                                [Currency] = N'BRL' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'ck' ,
                                [DialingCodes] = N'+682' ,
                                [ChineseName] = N'库克群岛'
                        WHERE   [CountryCode] = N'ck'


-- [CountryCode]=N'cl' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'cl' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'cl' ,
                                  N'Chile' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'cl' ,
                                  N'+56' ,
                                  N'智利'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Chile' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'cl' ,
                                [DialingCodes] = N'+56' ,
                                [ChineseName] = N'智利'
                        WHERE   [CountryCode] = N'cl'


-- [CountryCode]=N'cm' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'cm' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'cm' ,
                                  N'Cameroon' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'cm' ,
                                  N'+237' ,
                                  N'喀麦隆'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Cameroon' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'cm' ,
                                [DialingCodes] = N'+237' ,
                                [ChineseName] = N'喀麦隆'
                        WHERE   [CountryCode] = N'cm'


-- [CountryCode]=N'cn' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'cn' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'cn' ,
                                  N'China' ,
                                  N'CNY' ,
                                  N'cs' ,
                                  N'cn' ,
                                  N'cn' ,
                                  N'cn' ,
                                  N'+86' ,
                                  N'中国'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'China' ,
                                [Currency] = N'CNY' ,
                                [DefaultLanguage] = N'cs' ,
                                [Region] = N'cn' ,
                                [AccountingRegion] = N'cn' ,
                                [ISOLocaleCode] = N'cn' ,
                                [DialingCodes] = N'+86' ,
                                [ChineseName] = N'中国'
                        WHERE   [CountryCode] = N'cn'


-- [CountryCode]=N'co' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'co' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'co' ,
                                  N'Colombia' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'co' ,
                                  N'+57' ,
                                  N'哥伦比亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Colombia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'co' ,
                                [DialingCodes] = N'+57' ,
                                [ChineseName] = N'哥伦比亚'
                        WHERE   [CountryCode] = N'co'


-- [CountryCode]=N'cp' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'cp' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'cp' ,
                                  N'Cent. African Rep.' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'cp' ,
                                  N'+236' ,
                                  N'分.非洲'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Cent. African Rep.' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'cp' ,
                                [DialingCodes] = N'+236' ,
                                [ChineseName] = N'分.非洲'
                        WHERE   [CountryCode] = N'cp'


-- [CountryCode]=N'cr' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'cr' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'cr' ,
                                  N'Costa Rica' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'cr' ,
                                  N'+506' ,
                                  N'哥斯达黎加'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Costa Rica' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'cr' ,
                                [DialingCodes] = N'+506' ,
                                [ChineseName] = N'哥斯达黎加'
                        WHERE   [CountryCode] = N'cr'


-- [CountryCode]=N'cu' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'cu' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'cu' ,
                                  N'Cuba' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'cu' ,
                                  N'+53' ,
                                  N'古巴'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Cuba' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'cu' ,
                                [DialingCodes] = N'+53' ,
                                [ChineseName] = N'古巴'
                        WHERE   [CountryCode] = N'cu'


-- [CountryCode]=N'cv' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'cv' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'cv' ,
                                  N'Cape Verde' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'cv' ,
                                  N'+238' ,
                                  N'佛得角'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Cape Verde' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'cv' ,
                                [DialingCodes] = N'+238' ,
                                [ChineseName] = N'佛得角'
                        WHERE   [CountryCode] = N'cv'


-- [CountryCode]=N'cx' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'cx' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'cx' ,
                                  N'Christmas Island' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'cx' ,
                                  N'+61' ,
                                  N'圣诞岛'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Christmas Island' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'cx' ,
                                [DialingCodes] = N'+61' ,
                                [ChineseName] = N'圣诞岛'
                        WHERE   [CountryCode] = N'cx'


-- [CountryCode]=N'cy' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'cy' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'cy' ,
                                  N'Cyprus' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'cy' ,
                                  N'+357' ,
                                  N'塞浦路斯'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Cyprus' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'cy' ,
                                [DialingCodes] = N'+357' ,
                                [ChineseName] = N'塞浦路斯'
                        WHERE   [CountryCode] = N'cy'


-- [CountryCode]=N'cz' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'cz' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'cz' ,
                                  N'Czech Republic' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'cz' ,
                                  N'+420' ,
                                  N'捷克'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Czech Republic' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'cz' ,
                                [DialingCodes] = N'+420' ,
                                [ChineseName] = N'捷克'
                        WHERE   [CountryCode] = N'cz'


-- [CountryCode]=N'de' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'de' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'de' ,
                                  N'Germany' ,
                                  N'EUR' ,
                                  N'ge' ,
                                  N'de' ,
                                  N'de' ,
                                  N'de' ,
                                  N'+49' ,
                                  N'德国'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Germany' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'ge' ,
                                [Region] = N'de' ,
                                [AccountingRegion] = N'de' ,
                                [ISOLocaleCode] = N'de' ,
                                [DialingCodes] = N'+49' ,
                                [ChineseName] = N'德国'
                        WHERE   [CountryCode] = N'de'


-- [CountryCode]=N'dj' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'dj' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'dj' ,
                                  N'Djibouti' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'dj' ,
                                  N'+253' ,
                                  N'吉布提'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Djibouti' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'dj' ,
                                [DialingCodes] = N'+253' ,
                                [ChineseName] = N'吉布提'
                        WHERE   [CountryCode] = N'dj'


-- [CountryCode]=N'dk' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'dk' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'dk' ,
                                  N'Denmark' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'dk' ,
                                  N'+45' ,
                                  N'丹麦'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Denmark' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'dk' ,
                                [DialingCodes] = N'+45' ,
                                [ChineseName] = N'丹麦'
                        WHERE   [CountryCode] = N'dk'


-- [CountryCode]=N'dm' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'dm' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'dm' ,
                                  N'Dominica' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'dm' ,
                                  N'+1 767' ,
                                  N'多米尼亚共和国'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Dominica' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'dm' ,
                                [DialingCodes] = N'+1 767' ,
                                [ChineseName] = N'多米尼亚共和国'
                        WHERE   [CountryCode] = N'dm'


-- [CountryCode]=N'do' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'do' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'do' ,
                                  N'Dominican Republic' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'do' ,
                                  N'+1 809, +1 829, +1 849' ,
                                  N'多米尼加共和国'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Dominican Republic' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'do' ,
                                [DialingCodes] = N'+1 809, +1 829, +1 849' ,
                                [ChineseName] = N'多米尼加共和国'
                        WHERE   [CountryCode] = N'do'


-- [CountryCode]=N'dz' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'dz' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'dz' ,
                                  N'Algeria' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'dz' ,
                                  N'+213' ,
                                  N'阿尔及利亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Algeria' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'dz' ,
                                [DialingCodes] = N'+213' ,
                                [ChineseName] = N'阿尔及利亚'
                        WHERE   [CountryCode] = N'dz'


-- [CountryCode]=N'ec' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ec' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ec' ,
                                  N'Ecuador' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'ec' ,
                                  N'+593' ,
                                  N'厄瓜多尔'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Ecuador' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'ec' ,
                                [DialingCodes] = N'+593' ,
                                [ChineseName] = N'厄瓜多尔'
                        WHERE   [CountryCode] = N'ec'


-- [CountryCode]=N'ee' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ee' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ee' ,
                                  N'Estonia' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'ee' ,
                                  N'+372' ,
                                  N'爱沙尼亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Estonia' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'ee' ,
                                [DialingCodes] = N'+372' ,
                                [ChineseName] = N'爱沙尼亚'
                        WHERE   [CountryCode] = N'ee'


-- [CountryCode]=N'eg' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'eg' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'eg' ,
                                  N'Egypt' ,
                                  N'USD' ,
                                  N'ar' ,
                                  N'me' ,
                                  N'or' ,
                                  N'eg' ,
                                  N'+20' ,
                                  N'埃及'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Egypt' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'ar' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'eg' ,
                                [DialingCodes] = N'+20' ,
                                [ChineseName] = N'埃及'
                        WHERE   [CountryCode] = N'eg'


-- [CountryCode]=N'eh' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'eh' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'eh' ,
                                  N'Western Sahara' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'eh' ,
                                  N'+212 288, +212 289' ,
                                  N'西撒哈拉'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Western Sahara' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'eh' ,
                                [DialingCodes] = N'+212 288, +212 289' ,
                                [ChineseName] = N'西撒哈拉'
                        WHERE   [CountryCode] = N'eh'


-- [CountryCode]=N'er' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'er' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'er' ,
                                  N'Eritrea' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'er' ,
                                  N'+291' ,
                                  N'厄立特里亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Eritrea' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'er' ,
                                [DialingCodes] = N'+291' ,
                                [ChineseName] = N'厄立特里亚'
                        WHERE   [CountryCode] = N'er'


-- [CountryCode]=N'es' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'es' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'es' ,
                                  N'Spain' ,
                                  N'EUR' ,
                                  N'es' ,
                                  N'es' ,
                                  N'es' ,
                                  N'es' ,
                                  N'+34' ,
                                  N'西班牙'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Spain' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'es' ,
                                [Region] = N'es' ,
                                [AccountingRegion] = N'es' ,
                                [ISOLocaleCode] = N'es' ,
                                [DialingCodes] = N'+34' ,
                                [ChineseName] = N'西班牙'
                        WHERE   [CountryCode] = N'es'


-- [CountryCode]=N'et' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'et' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'et' ,
                                  N'Ethiopia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'et' ,
                                  N'+251' ,
                                  N'埃塞俄比亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Ethiopia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'et' ,
                                [DialingCodes] = N'+251' ,
                                [ChineseName] = N'埃塞俄比亚'
                        WHERE   [CountryCode] = N'et'


-- [CountryCode]=N'fi' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'fi' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'fi' ,
                                  N'Finland' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'fi' ,
                                  N'+358' ,
                                  N'芬兰'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Finland' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'fi' ,
                                [DialingCodes] = N'+358' ,
                                [ChineseName] = N'芬兰'
                        WHERE   [CountryCode] = N'fi'


-- [CountryCode]=N'fj' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'fj' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'fj' ,
                                  N'Fiji' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'fj' ,
                                  N'+679' ,
                                  N'斐济'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Fiji' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'fj' ,
                                [DialingCodes] = N'+679' ,
                                [ChineseName] = N'斐济'
                        WHERE   [CountryCode] = N'fj'


-- [CountryCode]=N'fk' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'fk' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'fk' ,
                                  N'Falkland Islands' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'fk' ,
                                  N'+500' ,
                                  N'福克兰群岛'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Falkland Islands' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'fk' ,
                                [DialingCodes] = N'+500' ,
                                [ChineseName] = N'福克兰群岛'
                        WHERE   [CountryCode] = N'fk'


-- [CountryCode]=N'fm' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'fm' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'fm' ,
                                  N'Micronesia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'fm' ,
                                  N'+691' ,
                                  N'密克罗尼西亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Micronesia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'fm' ,
                                [DialingCodes] = N'+691' ,
                                [ChineseName] = N'密克罗尼西亚'
                        WHERE   [CountryCode] = N'fm'


-- [CountryCode]=N'fo' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'fo' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'fo' ,
                                  N'Faroe Islands' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'fo' ,
                                  N'+298' ,
                                  N'法罗群岛'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Faroe Islands' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'fo' ,
                                [DialingCodes] = N'+298' ,
                                [ChineseName] = N'法罗群岛'
                        WHERE   [CountryCode] = N'fo'


-- [CountryCode]=N'fr' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'fr' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'fr' ,
                                  N'France' ,
                                  N'EUR' ,
                                  N'fr' ,
                                  N'fr' ,
                                  N'uf' ,
                                  N'fr' ,
                                  N'+33' ,
                                  N'法国'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'France' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'fr' ,
                                [Region] = N'fr' ,
                                [AccountingRegion] = N'uf' ,
                                [ISOLocaleCode] = N'fr' ,
                                [DialingCodes] = N'+33' ,
                                [ChineseName] = N'法国'
                        WHERE   [CountryCode] = N'fr'


-- [CountryCode]=N'ga' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ga' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ga' ,
                                  N'Gabon' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'ga' ,
                                  N'+241' ,
                                  N'加蓬'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Gabon' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'ga' ,
                                [DialingCodes] = N'+241' ,
                                [ChineseName] = N'加蓬'
                        WHERE   [CountryCode] = N'ga'


-- [CountryCode]=N'gb' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'gb' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'gb' ,
                                  N'United Kingdom' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'uf' ,
                                  N'gb' ,
                                  N'+44' ,
                                  N'英国'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'United Kingdom' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'uf' ,
                                [ISOLocaleCode] = N'gb' ,
                                [DialingCodes] = N'+44' ,
                                [ChineseName] = N'英国'
                        WHERE   [CountryCode] = N'gb'


-- [CountryCode]=N'gd' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'gd' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'gd' ,
                                  N'Grenada' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'gd' ,
                                  N'+1 473' ,
                                  N'格林纳达'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Grenada' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'gd' ,
                                [DialingCodes] = N'+1 473' ,
                                [ChineseName] = N'格林纳达'
                        WHERE   [CountryCode] = N'gd'


-- [CountryCode]=N'ge' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ge' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ge' ,
                                  N'Georgia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'ge' ,
                                  N'+995' ,
                                  N'格鲁吉亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Georgia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'ge' ,
                                [DialingCodes] = N'+995' ,
                                [ChineseName] = N'格鲁吉亚'
                        WHERE   [CountryCode] = N'ge'


-- [CountryCode]=N'gf' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'gf' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'gf' ,
                                  N'French Guiana' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'or' ,
                                  N'gf' ,
                                  N'+594' ,
                                  N'法属圭亚那'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'French Guiana' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'gf' ,
                                [DialingCodes] = N'+594' ,
                                [ChineseName] = N'法属圭亚那'
                        WHERE   [CountryCode] = N'gf'


-- [CountryCode]=N'gh' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'gh' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'gh' ,
                                  N'Ghana' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'gh' ,
                                  N'+233' ,
                                  N'加纳'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Ghana' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'gh' ,
                                [DialingCodes] = N'+233' ,
                                [ChineseName] = N'加纳'
                        WHERE   [CountryCode] = N'gh'


-- [CountryCode]=N'gi' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'gi' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'gi' ,
                                  N'Gibraltar' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'gi' ,
                                  N'+350' ,
                                  N'直布罗陀'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Gibraltar' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'gi' ,
                                [DialingCodes] = N'+350' ,
                                [ChineseName] = N'直布罗陀'
                        WHERE   [CountryCode] = N'gi'


-- [CountryCode]=N'gl' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'gl' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'gl' ,
                                  N'Greenland' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'gl' ,
                                  N'+299' ,
                                  N'格陵兰'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Greenland' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'gl' ,
                                [DialingCodes] = N'+299' ,
                                [ChineseName] = N'格陵兰'
                        WHERE   [CountryCode] = N'gl'


-- [CountryCode]=N'gm' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'gm' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'gm' ,
                                  N'Gambia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'gm' ,
                                  N'+220' ,
                                  N'冈比亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Gambia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'gm' ,
                                [DialingCodes] = N'+220' ,
                                [ChineseName] = N'冈比亚'
                        WHERE   [CountryCode] = N'gm'


-- [CountryCode]=N'gn' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'gn' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'gn' ,
                                  N'Guinea' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'gn' ,
                                  N'+224' ,
                                  N'几内亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Guinea' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'gn' ,
                                [DialingCodes] = N'+224' ,
                                [ChineseName] = N'几内亚'
                        WHERE   [CountryCode] = N'gn'


-- [CountryCode]=N'gp' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'gp' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'gp' ,
                                  N'Guadeloupe' ,
                                  N'EUR' ,
                                  N'fr' ,
                                  N'eu' ,
                                  N'ln' ,
                                  N'gp' ,
                                  N'+590' ,
                                  N'瓜德罗普'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Guadeloupe' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'fr' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'gp' ,
                                [DialingCodes] = N'+590' ,
                                [ChineseName] = N'瓜德罗普'
                        WHERE   [CountryCode] = N'gp'


-- [CountryCode]=N'gq' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'gq' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'gq' ,
                                  N'Equatorial Guinea' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'gq' ,
                                  N'+240' ,
                                  N'赤道几内亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Equatorial Guinea' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'gq' ,
                                [DialingCodes] = N'+240' ,
                                [ChineseName] = N'赤道几内亚'
                        WHERE   [CountryCode] = N'gq'


-- [CountryCode]=N'gr' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'gr' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'gr' ,
                                  N'Greece' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'gr' ,
                                  N'+30' ,
                                  N'希腊'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Greece' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'gr' ,
                                [DialingCodes] = N'+30' ,
                                [ChineseName] = N'希腊'
                        WHERE   [CountryCode] = N'gr'


-- [CountryCode]=N'gt' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'gt' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'gt' ,
                                  N'Guatemala' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'gt' ,
                                  N'+502' ,
                                  N'危地马拉'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Guatemala' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'gt' ,
                                [DialingCodes] = N'+502' ,
                                [ChineseName] = N'危地马拉'
                        WHERE   [CountryCode] = N'gt'


-- [CountryCode]=N'gu' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'gu' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'gu' ,
                                  N'Guam' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'gu' ,
                                  N'+1 671' ,
                                  N'关岛'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Guam' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'gu' ,
                                [DialingCodes] = N'+1 671' ,
                                [ChineseName] = N'关岛'
                        WHERE   [CountryCode] = N'gu'


-- [CountryCode]=N'gw' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'gw' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'gw' ,
                                  N'Guinea Bissau' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'gw' ,
                                  N'+245' ,
                                  N'几内亚(比绍)'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Guinea Bissau' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'gw' ,
                                [DialingCodes] = N'+245' ,
                                [ChineseName] = N'几内亚(比绍)'
                        WHERE   [CountryCode] = N'gw'


-- [CountryCode]=N'gy' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'gy' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'gy' ,
                                  N'Guyana' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'gy' ,
                                  N'+592' ,
                                  N'圭亚那'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Guyana' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'gy' ,
                                [DialingCodes] = N'+592' ,
                                [ChineseName] = N'圭亚那'
                        WHERE   [CountryCode] = N'gy'


-- [CountryCode]=N'hk' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'hk' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'hk' ,
                                  N'Hong Kong' ,
                                  N'HKD' ,
                                  N'hk' ,
                                  N'hk' ,
                                  N'aa' ,
                                  N'hk' ,
                                  N'+852' ,
                                  N'中国香港'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Hong Kong' ,
                                [Currency] = N'HKD' ,
                                [DefaultLanguage] = N'hk' ,
                                [Region] = N'hk' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'hk' ,
                                [DialingCodes] = N'+852' ,
                                [ChineseName] = N'中国香港'
                        WHERE   [CountryCode] = N'hk'


-- [CountryCode]=N'hn' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'hn' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'hn' ,
                                  N'Honduras' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'hn' ,
                                  N'+504' ,
                                  N'洪都拉斯'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Honduras' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'hn' ,
                                [DialingCodes] = N'+504' ,
                                [ChineseName] = N'洪都拉斯'
                        WHERE   [CountryCode] = N'hn'


-- [CountryCode]=N'hr' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'hr' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'hr' ,
                                  N'Croatia' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'hr' ,
                                  N'+385' ,
                                  N'克罗地亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Croatia' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'hr' ,
                                [DialingCodes] = N'+385' ,
                                [ChineseName] = N'克罗地亚'
                        WHERE   [CountryCode] = N'hr'


-- [CountryCode]=N'ht' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ht' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ht' ,
                                  N'Haiti' ,
                                  N'USD' ,
                                  N'fr' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'ht' ,
                                  N'+509' ,
                                  N'海地'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Haiti' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'fr' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'ht' ,
                                [DialingCodes] = N'+509' ,
                                [ChineseName] = N'海地'
                        WHERE   [CountryCode] = N'ht'


-- [CountryCode]=N'hu' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'hu' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'hu' ,
                                  N'Hungary' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'hu' ,
                                  N'+36' ,
                                  N'匈牙利'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Hungary' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'hu' ,
                                [DialingCodes] = N'+36' ,
                                [ChineseName] = N'匈牙利'
                        WHERE   [CountryCode] = N'hu'


-- [CountryCode]=N'id' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'id' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'id' ,
                                  N'Indonesia' ,
                                  N'USD' ,
                                  N'in' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'id' ,
                                  N'+62' ,
                                  N'印度尼西亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Indonesia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'in' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'id' ,
                                [DialingCodes] = N'+62' ,
                                [ChineseName] = N'印度尼西亚'
                        WHERE   [CountryCode] = N'id'


-- [CountryCode]=N'ie' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ie' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ie' ,
                                  N'Ireland' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'ie' ,
                                  N'+353' ,
                                  N'爱尔兰'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Ireland' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'ie' ,
                                [DialingCodes] = N'+353' ,
                                [ChineseName] = N'爱尔兰'
                        WHERE   [CountryCode] = N'ie'


-- [CountryCode]=N'il' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'il' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'il' ,
                                  N'Israel' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'me' ,
                                  N'or' ,
                                  N'il' ,
                                  N'+972' ,
                                  N'以色列'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Israel' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'il' ,
                                [DialingCodes] = N'+972' ,
                                [ChineseName] = N'以色列'
                        WHERE   [CountryCode] = N'il'


-- [CountryCode]=N'in' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'in' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'in' ,
                                  N'India' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'in' ,
                                  N'+91' ,
                                  N'印度'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'India' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'in' ,
                                [DialingCodes] = N'+91' ,
                                [ChineseName] = N'印度'
                        WHERE   [CountryCode] = N'in'


-- [CountryCode]=N'iq' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'iq' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'iq' ,
                                  N'Iraq' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'me' ,
                                  N'or' ,
                                  N'iq' ,
                                  N'+964' ,
                                  N'伊拉克'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Iraq' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'iq' ,
                                [DialingCodes] = N'+964' ,
                                [ChineseName] = N'伊拉克'
                        WHERE   [CountryCode] = N'iq'


-- [CountryCode]=N'ir' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ir' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ir' ,
                                  N'Iran' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'me' ,
                                  N'or' ,
                                  N'ir' ,
                                  N'+98' ,
                                  N'伊朗'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Iran' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'ir' ,
                                [DialingCodes] = N'+98' ,
                                [ChineseName] = N'伊朗'
                        WHERE   [CountryCode] = N'ir'


-- [CountryCode]=N'is' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'is' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'is' ,
                                  N'Iceland' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'is' ,
                                  N'+354' ,
                                  N'冰岛'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Iceland' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'is' ,
                                [DialingCodes] = N'+354' ,
                                [ChineseName] = N'冰岛'
                        WHERE   [CountryCode] = N'is'


-- [CountryCode]=N'it' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'it' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'it' ,
                                  N'Italy' ,
                                  N'EUR' ,
                                  N'it' ,
                                  N'it' ,
                                  N'it' ,
                                  N'it' ,
                                  N'+39' ,
                                  N'意大利'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Italy' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'it' ,
                                [Region] = N'it' ,
                                [AccountingRegion] = N'it' ,
                                [ISOLocaleCode] = N'it' ,
                                [DialingCodes] = N'+39' ,
                                [ChineseName] = N'意大利'
                        WHERE   [CountryCode] = N'it'


-- [CountryCode]=N'jm' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'jm' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'jm' ,
                                  N'Jamaica' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'jm' ,
                                  N'+1 876' ,
                                  N'牙买加'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Jamaica' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'jm' ,
                                [DialingCodes] = N'+1 876' ,
                                [ChineseName] = N'牙买加'
                        WHERE   [CountryCode] = N'jm'


-- [CountryCode]=N'jo' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'jo' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'jo' ,
                                  N'Jordan' ,
                                  N'USD' ,
                                  N'ar' ,
                                  N'me' ,
                                  N'or' ,
                                  N'jo' ,
                                  N'+962' ,
                                  N'约旦'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Jordan' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'ar' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'jo' ,
                                [DialingCodes] = N'+962' ,
                                [ChineseName] = N'约旦'
                        WHERE   [CountryCode] = N'jo'


-- [CountryCode]=N'jp' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'jp' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'jp' ,
                                  N'Japan' ,
                                  N'JPY' ,
                                  N'ja' ,
                                  N'jp' ,
                                  N'jp' ,
                                  N'jp' ,
                                  N'+81' ,
                                  N'日本'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Japan' ,
                                [Currency] = N'JPY' ,
                                [DefaultLanguage] = N'ja' ,
                                [Region] = N'jp' ,
                                [AccountingRegion] = N'jp' ,
                                [ISOLocaleCode] = N'jp' ,
                                [DialingCodes] = N'+81' ,
                                [ChineseName] = N'日本'
                        WHERE   [CountryCode] = N'jp'


-- [CountryCode]=N'ke' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ke' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ke' ,
                                  N'Kenya' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'ke' ,
                                  N'+254' ,
                                  N'肯尼亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Kenya' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'ke' ,
                                [DialingCodes] = N'+254' ,
                                [ChineseName] = N'肯尼亚'
                        WHERE   [CountryCode] = N'ke'


-- [CountryCode]=N'kg' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'kg' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'kg' ,
                                  N'Kyrgyzstan' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'me' ,
                                  N'eu' ,
                                  N'kg' ,
                                  N'+996' ,
                                  N'吉尔吉斯斯坦'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Kyrgyzstan' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'kg' ,
                                [DialingCodes] = N'+996' ,
                                [ChineseName] = N'吉尔吉斯斯坦'
                        WHERE   [CountryCode] = N'kg'


-- [CountryCode]=N'kh' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'kh' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'kh' ,
                                  N'Cambodia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'kh' ,
                                  N'+855' ,
                                  N'柬埔寨'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Cambodia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'kh' ,
                                [DialingCodes] = N'+855' ,
                                [ChineseName] = N'柬埔寨'
                        WHERE   [CountryCode] = N'kh'


-- [CountryCode]=N'ki' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ki' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ki' ,
                                  N'Kiribati' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'ki' ,
                                  N'+686' ,
                                  N'基里巴斯'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Kiribati' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'ki' ,
                                [DialingCodes] = N'+686' ,
                                [ChineseName] = N'基里巴斯'
                        WHERE   [CountryCode] = N'ki'


-- [CountryCode]=N'km' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'km' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'km' ,
                                  N'Comoros' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'km' ,
                                  N'+269' ,
                                  N'科摩罗'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Comoros' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'km' ,
                                [DialingCodes] = N'+269' ,
                                [ChineseName] = N'科摩罗'
                        WHERE   [CountryCode] = N'km'


-- [CountryCode]=N'kn' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'kn' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'kn' ,
                                  N'Saint Kitts' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'kn' ,
                                  N'+1 869' ,
                                  N'圣基茨'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Saint Kitts' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'kn' ,
                                [DialingCodes] = N'+1 869' ,
                                [ChineseName] = N'圣基茨'
                        WHERE   [CountryCode] = N'kn'


-- [CountryCode]=N'kp' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'kp' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'kp' ,
                                  N'North Korea' ,
                                  N'USD' ,
                                  N'ko' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'kp' ,
                                  N'+850' ,
                                  N'朝鲜'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'North Korea' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'ko' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'kp' ,
                                [DialingCodes] = N'+850' ,
                                [ChineseName] = N'朝鲜'
                        WHERE   [CountryCode] = N'kp'


-- [CountryCode]=N'kr' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'kr' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'kr' ,
                                  N'Korea' ,
                                  N'KRW' ,
                                  N'ko' ,
                                  N'kr' ,
                                  N'kr' ,
                                  N'kr' ,
                                  N'+82' ,
                                  N'韩国'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Korea' ,
                                [Currency] = N'KRW' ,
                                [DefaultLanguage] = N'ko' ,
                                [Region] = N'kr' ,
                                [AccountingRegion] = N'kr' ,
                                [ISOLocaleCode] = N'kr' ,
                                [DialingCodes] = N'+82' ,
                                [ChineseName] = N'韩国'
                        WHERE   [CountryCode] = N'kr'


-- [CountryCode]=N'kw' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'kw' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'kw' ,
                                  N'Kuwait' ,
                                  N'USD' ,
                                  N'ar' ,
                                  N'me' ,
                                  N'or' ,
                                  N'kw' ,
                                  N'+965' ,
                                  N'科威特'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Kuwait' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'ar' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'kw' ,
                                [DialingCodes] = N'+965' ,
                                [ChineseName] = N'科威特'
                        WHERE   [CountryCode] = N'kw'


-- [CountryCode]=N'ky' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ky' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ky' ,
                                  N'Cayman Islands' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'ky' ,
                                  N'+1 345' ,
                                  N'开曼群岛'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Cayman Islands' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'ky' ,
                                [DialingCodes] = N'+1 345' ,
                                [ChineseName] = N'开曼群岛'
                        WHERE   [CountryCode] = N'ky'


-- [CountryCode]=N'kz' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'kz' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'kz' ,
                                  N'Kazakhstan' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'kz' ,
                                  N'+7 6, +7 7' ,
                                  N'哈萨克斯坦'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Kazakhstan' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'kz' ,
                                [DialingCodes] = N'+7 6, +7 7' ,
                                [ChineseName] = N'哈萨克斯坦'
                        WHERE   [CountryCode] = N'kz'


-- [CountryCode]=N'la' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'la' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'la' ,
                                  N'Laos' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'la' ,
                                  N'+856' ,
                                  N'老挝'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Laos' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'la' ,
                                [DialingCodes] = N'+856' ,
                                [ChineseName] = N'老挝'
                        WHERE   [CountryCode] = N'la'


-- [CountryCode]=N'lb' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'lb' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'lb' ,
                                  N'Lebanon' ,
                                  N'USD' ,
                                  N'ar' ,
                                  N'me' ,
                                  N'or' ,
                                  N'lb' ,
                                  N'+961' ,
                                  N'黎巴嫩'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Lebanon' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'ar' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'lb' ,
                                [DialingCodes] = N'+961' ,
                                [ChineseName] = N'黎巴嫩'
                        WHERE   [CountryCode] = N'lb'


-- [CountryCode]=N'lc' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'lc' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'lc' ,
                                  N'Saint Lucia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'lc' ,
                                  N'+1 758' ,
                                  N'圣卢西亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Saint Lucia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'lc' ,
                                [DialingCodes] = N'+1 758' ,
                                [ChineseName] = N'圣卢西亚'
                        WHERE   [CountryCode] = N'lc'


-- [CountryCode]=N'li' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'li' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'li' ,
                                  N'Liechtenstein' ,
                                  N'EUR' ,
                                  N'ge' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'li' ,
                                  N'+423' ,
                                  N'列支敦士登'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Liechtenstein' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'ge' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'li' ,
                                [DialingCodes] = N'+423' ,
                                [ChineseName] = N'列支敦士登'
                        WHERE   [CountryCode] = N'li'


-- [CountryCode]=N'lk' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'lk' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'lk' ,
                                  N'Sri Lanka' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'lk' ,
                                  N'+94' ,
                                  N'斯里兰卡'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Sri Lanka' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'lk' ,
                                [DialingCodes] = N'+94' ,
                                [ChineseName] = N'斯里兰卡'
                        WHERE   [CountryCode] = N'lk'


-- [CountryCode]=N'lr' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'lr' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'lr' ,
                                  N'Liberia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'lr' ,
                                  N'+231' ,
                                  N'利比里亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Liberia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'lr' ,
                                [DialingCodes] = N'+231' ,
                                [ChineseName] = N'利比里亚'
                        WHERE   [CountryCode] = N'lr'


-- [CountryCode]=N'ls' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ls' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ls' ,
                                  N'Lesotho' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'ls' ,
                                  N'+266' ,
                                  N'莱索托'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Lesotho' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'ls' ,
                                [DialingCodes] = N'+266' ,
                                [ChineseName] = N'莱索托'
                        WHERE   [CountryCode] = N'ls'


-- [CountryCode]=N'lt' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'lt' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'lt' ,
                                  N'Lithuania' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'lt' ,
                                  N'+370' ,
                                  N'立陶宛'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Lithuania' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'lt' ,
                                [DialingCodes] = N'+370' ,
                                [ChineseName] = N'立陶宛'
                        WHERE   [CountryCode] = N'lt'


-- [CountryCode]=N'lu' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'lu' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'lu' ,
                                  N'Luxembourg' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'lu' ,
                                  N'+352' ,
                                  N'卢森堡'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Luxembourg' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'lu' ,
                                [DialingCodes] = N'+352' ,
                                [ChineseName] = N'卢森堡'
                        WHERE   [CountryCode] = N'lu'


-- [CountryCode]=N'lv' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'lv' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'lv' ,
                                  N'Latvia' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'lv' ,
                                  N'+371' ,
                                  N'拉脱维亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Latvia' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'lv' ,
                                [DialingCodes] = N'+371' ,
                                [ChineseName] = N'拉脱维亚'
                        WHERE   [CountryCode] = N'lv'


-- [CountryCode]=N'ly' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ly' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ly' ,
                                  N'Libya' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'ly' ,
                                  N'+218' ,
                                  N'利比亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Libya' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'ly' ,
                                [DialingCodes] = N'+218' ,
                                [ChineseName] = N'利比亚'
                        WHERE   [CountryCode] = N'ly'


-- [CountryCode]=N'ma' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ma' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ma' ,
                                  N'Morocco' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'ma' ,
                                  N'+212' ,
                                  N'摩洛哥'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Morocco' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'ma' ,
                                [DialingCodes] = N'+212' ,
                                [ChineseName] = N'摩洛哥'
                        WHERE   [CountryCode] = N'ma'


-- [CountryCode]=N'mc' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'mc' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'mc' ,
                                  N'Monaco' ,
                                  N'EUR' ,
                                  N'fr' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'mc' ,
                                  N'+377' ,
                                  N'摩纳哥'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Monaco' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'fr' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'mc' ,
                                [DialingCodes] = N'+377' ,
                                [ChineseName] = N'摩纳哥'
                        WHERE   [CountryCode] = N'mc'


-- [CountryCode]=N'md' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'md' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'md' ,
                                  N'Moldova' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'md' ,
                                  N'+373' ,
                                  N'摩尔多瓦'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Moldova' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'md' ,
                                [DialingCodes] = N'+373' ,
                                [ChineseName] = N'摩尔多瓦'
                        WHERE   [CountryCode] = N'md'


-- [CountryCode]=N'me' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'me' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'me' ,
                                  N'Montenegro' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'me' ,
                                  NULL ,
                                  N'黑山'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Montenegro' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'me' ,
                                [DialingCodes] = NULL ,
                                [ChineseName] = N'黑山'
                        WHERE   [CountryCode] = N'me'


-- [CountryCode]=N'mg' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'mg' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'mg' ,
                                  N'Madagascar' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'mg' ,
                                  N'+261' ,
                                  N'马达加斯加'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Madagascar' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'mg' ,
                                [DialingCodes] = N'+261' ,
                                [ChineseName] = N'马达加斯加'
                        WHERE   [CountryCode] = N'mg'


-- [CountryCode]=N'mh' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'mh' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'mh' ,
                                  N'Marshall Islands' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'mh' ,
                                  N'+692' ,
                                  N'马绍尔群岛'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Marshall Islands' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'mh' ,
                                [DialingCodes] = N'+692' ,
                                [ChineseName] = N'马绍尔群岛'
                        WHERE   [CountryCode] = N'mh'


-- [CountryCode]=N'mk' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'mk' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'mk' ,
                                  N'Macedonia' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'mk' ,
                                  N'+389' ,
                                  N'马其顿'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Macedonia' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'mk' ,
                                [DialingCodes] = N'+389' ,
                                [ChineseName] = N'马其顿'
                        WHERE   [CountryCode] = N'mk'


-- [CountryCode]=N'ml' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ml' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ml' ,
                                  N'Mali' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'ml' ,
                                  N'+223' ,
                                  N'马里'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Mali' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'ml' ,
                                [DialingCodes] = N'+223' ,
                                [ChineseName] = N'马里'
                        WHERE   [CountryCode] = N'ml'


-- [CountryCode]=N'mm' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'mm' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'mm' ,
                                  N'Myanmar' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'mm' ,
                                  NULL ,
                                  N'缅甸'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Myanmar' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'mm' ,
                                [DialingCodes] = NULL ,
                                [ChineseName] = N'缅甸'
                        WHERE   [CountryCode] = N'mm'


-- [CountryCode]=N'mn' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'mn' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'mn' ,
                                  N'Monlia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'mn' ,
                                  N'+976' ,
                                  N'蒙古'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Monlia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'mn' ,
                                [DialingCodes] = N'+976' ,
                                [ChineseName] = N'蒙古'
                        WHERE   [CountryCode] = N'mn'


-- [CountryCode]=N'mo' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'mo' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'mo' ,
                                  N'Macau' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'mo' ,
                                  N'+853' ,
                                  N'中国澳门'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Macau' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'mo' ,
                                [DialingCodes] = N'+853' ,
                                [ChineseName] = N'中国澳门'
                        WHERE   [CountryCode] = N'mo'


-- [CountryCode]=N'mq' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'mq' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'mq' ,
                                  N'Martinique' ,
                                  N'EUR' ,
                                  N'fr' ,
                                  N'eu' ,
                                  N'ln' ,
                                  N'mq' ,
                                  N'+596' ,
                                  N'马提尼克'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Martinique' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'fr' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'mq' ,
                                [DialingCodes] = N'+596' ,
                                [ChineseName] = N'马提尼克'
                        WHERE   [CountryCode] = N'mq'


-- [CountryCode]=N'mr' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'mr' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'mr' ,
                                  N'Mauritania' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'mr' ,
                                  N'+222' ,
                                  N'毛里塔尼亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Mauritania' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'mr' ,
                                [DialingCodes] = N'+222' ,
                                [ChineseName] = N'毛里塔尼亚'
                        WHERE   [CountryCode] = N'mr'


-- [CountryCode]=N'mt' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'mt' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'mt' ,
                                  N'Malta' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'mt' ,
                                  N'+356' ,
                                  N'马耳他'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Malta' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'mt' ,
                                [DialingCodes] = N'+356' ,
                                [ChineseName] = N'马耳他'
                        WHERE   [CountryCode] = N'mt'


-- [CountryCode]=N'mu' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'mu' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'mu' ,
                                  N'Mauritius' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'mu' ,
                                  N'+230' ,
                                  N'毛里求斯'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Mauritius' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'mu' ,
                                [DialingCodes] = N'+230' ,
                                [ChineseName] = N'毛里求斯'
                        WHERE   [CountryCode] = N'mu'


-- [CountryCode]=N'mv' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'mv' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'mv' ,
                                  N'Maldives' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'mv' ,
                                  N'+960' ,
                                  N'马尔代夫'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Maldives' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'mv' ,
                                [DialingCodes] = N'+960' ,
                                [ChineseName] = N'马尔代夫'
                        WHERE   [CountryCode] = N'mv'


-- [CountryCode]=N'mw' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'mw' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'mw' ,
                                  N'Malawi' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'mw' ,
                                  N'+265' ,
                                  N'马拉维'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Malawi' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'mw' ,
                                [DialingCodes] = N'+265' ,
                                [ChineseName] = N'马拉维'
                        WHERE   [CountryCode] = N'mw'


-- [CountryCode]=N'mx' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'mx' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'mx' ,
                                  N'Mexico' ,
                                  N'MXN' ,
                                  N'mx' ,
                                  N'mx' ,
                                  N'mx' ,
                                  N'mx' ,
                                  N'+52' ,
                                  N'墨西哥'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Mexico' ,
                                [Currency] = N'MXN' ,
                                [DefaultLanguage] = N'mx' ,
                                [Region] = N'mx' ,
                                [AccountingRegion] = N'mx' ,
                                [ISOLocaleCode] = N'mx' ,
                                [DialingCodes] = N'+52' ,
                                [ChineseName] = N'墨西哥'
                        WHERE   [CountryCode] = N'mx'


-- [CountryCode]=N'my' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'my' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'my' ,
                                  N'Malaysia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'my' ,
                                  N'+60' ,
                                  N'马来西亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Malaysia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'my' ,
                                [DialingCodes] = N'+60' ,
                                [ChineseName] = N'马来西亚'
                        WHERE   [CountryCode] = N'my'


-- [CountryCode]=N'mz' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'mz' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'mz' ,
                                  N'Mozambique' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'mz' ,
                                  N'+258' ,
                                  N'莫桑比克'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Mozambique' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'mz' ,
                                [DialingCodes] = N'+258' ,
                                [ChineseName] = N'莫桑比克'
                        WHERE   [CountryCode] = N'mz'


-- [CountryCode]=N'na' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'na' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'na' ,
                                  N'Namibia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'na' ,
                                  N'+264' ,
                                  N'纳米比亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Namibia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'na' ,
                                [DialingCodes] = N'+264' ,
                                [ChineseName] = N'纳米比亚'
                        WHERE   [CountryCode] = N'na'


-- [CountryCode]=N'nc' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'nc' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'nc' ,
                                  N'New Caledonia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'nc' ,
                                  N'+687' ,
                                  N'新喀里多尼亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'New Caledonia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'nc' ,
                                [DialingCodes] = N'+687' ,
                                [ChineseName] = N'新喀里多尼亚'
                        WHERE   [CountryCode] = N'nc'


-- [CountryCode]=N'ne' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ne' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ne' ,
                                  N'Niger' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'ne' ,
                                  N'+227' ,
                                  N'尼日尔'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Niger' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'ne' ,
                                [DialingCodes] = N'+227' ,
                                [ChineseName] = N'尼日尔'
                        WHERE   [CountryCode] = N'ne'


-- [CountryCode]=N'nf' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'nf' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'nf' ,
                                  N'Norfolk Island' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'nf' ,
                                  N'+672' ,
                                  N'诺福克岛'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Norfolk Island' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'nf' ,
                                [DialingCodes] = N'+672' ,
                                [ChineseName] = N'诺福克岛'
                        WHERE   [CountryCode] = N'nf'


-- [CountryCode]=N'ng' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ng' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ng' ,
                                  N'Nigeria' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'ng' ,
                                  N'+234' ,
                                  N'尼日利亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Nigeria' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'ng' ,
                                [DialingCodes] = N'+234' ,
                                [ChineseName] = N'尼日利亚'
                        WHERE   [CountryCode] = N'ng'


-- [CountryCode]=N'ni' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ni' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ni' ,
                                  N'Nicaragua' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'ni' ,
                                  N'+505' ,
                                  N'尼加拉瓜'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Nicaragua' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'ni' ,
                                [DialingCodes] = N'+505' ,
                                [ChineseName] = N'尼加拉瓜'
                        WHERE   [CountryCode] = N'ni'


-- [CountryCode]=N'nl' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'nl' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'nl' ,
                                  N'Netherlands' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'nl' ,
                                  N'+31' ,
                                  N'荷兰'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Netherlands' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'nl' ,
                                [DialingCodes] = N'+31' ,
                                [ChineseName] = N'荷兰'
                        WHERE   [CountryCode] = N'nl'


-- [CountryCode]=N'no' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'no' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'no' ,
                                  N'Norway' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'no' ,
                                  N'+47' ,
                                  N'挪威'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Norway' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'no' ,
                                [DialingCodes] = N'+47' ,
                                [ChineseName] = N'挪威'
                        WHERE   [CountryCode] = N'no'


-- [CountryCode]=N'np' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'np' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'np' ,
                                  N'Nepal' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'np' ,
                                  N'+977' ,
                                  N'尼泊尔'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Nepal' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'np' ,
                                [DialingCodes] = N'+977' ,
                                [ChineseName] = N'尼泊尔'
                        WHERE   [CountryCode] = N'np'


-- [CountryCode]=N'nr' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'nr' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'nr' ,
                                  N'Nauru' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'nr' ,
                                  N'+674' ,
                                  N'瑙鲁'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Nauru' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'nr' ,
                                [DialingCodes] = N'+674' ,
                                [ChineseName] = N'瑙鲁'
                        WHERE   [CountryCode] = N'nr'


-- [CountryCode]=N'nu' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'nu' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'nu' ,
                                  N'Niue' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'nu' ,
                                  N'+683' ,
                                  N'纽埃'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Niue' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'nu' ,
                                [DialingCodes] = N'+683' ,
                                [ChineseName] = N'纽埃'
                        WHERE   [CountryCode] = N'nu'


-- [CountryCode]=N'nz' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'nz' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'nz' ,
                                  N'New Zealand' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'nz' ,
                                  N'+64' ,
                                  N'新西兰'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'New Zealand' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'nz' ,
                                [DialingCodes] = N'+64' ,
                                [ChineseName] = N'新西兰'
                        WHERE   [CountryCode] = N'nz'


-- [CountryCode]=N'om' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'om' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'om' ,
                                  N'Oman' ,
                                  N'USD' ,
                                  N'ar' ,
                                  N'me' ,
                                  N'or' ,
                                  N'om' ,
                                  N'+968' ,
                                  N'阿曼'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Oman' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'ar' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'om' ,
                                [DialingCodes] = N'+968' ,
                                [ChineseName] = N'阿曼'
                        WHERE   [CountryCode] = N'om'


-- [CountryCode]=N'ot' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ot' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ot' ,
                                  N'Other' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'ot' ,
                                  NULL ,
                                  N'其它'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Other' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'ot' ,
                                [DialingCodes] = NULL ,
                                [ChineseName] = N'其它'
                        WHERE   [CountryCode] = N'ot'


-- [CountryCode]=N'pa' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'pa' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'pa' ,
                                  N'Panama' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'pa' ,
                                  N'+507' ,
                                  N'巴拿马'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Panama' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'pa' ,
                                [DialingCodes] = N'+507' ,
                                [ChineseName] = N'巴拿马'
                        WHERE   [CountryCode] = N'pa'


-- [CountryCode]=N'pe' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'pe' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'pe' ,
                                  N'Peru' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'pe' ,
                                  N'+51' ,
                                  N'秘鲁'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Peru' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'pe' ,
                                [DialingCodes] = N'+51' ,
                                [ChineseName] = N'秘鲁'
                        WHERE   [CountryCode] = N'pe'


-- [CountryCode]=N'pf' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'pf' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'pf' ,
                                  N'French Polynesia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'pf' ,
                                  N'+689' ,
                                  N'法属波利尼西亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'French Polynesia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'pf' ,
                                [DialingCodes] = N'+689' ,
                                [ChineseName] = N'法属波利尼西亚'
                        WHERE   [CountryCode] = N'pf'


-- [CountryCode]=N'pg' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'pg' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'pg' ,
                                  N'Papua New Guinea' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'pg' ,
                                  N'+675' ,
                                  N'巴布亚新几内亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Papua New Guinea' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'pg' ,
                                [DialingCodes] = N'+675' ,
                                [ChineseName] = N'巴布亚新几内亚'
                        WHERE   [CountryCode] = N'pg'


-- [CountryCode]=N'ph' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ph' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ph' ,
                                  N'Philippines' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'ph' ,
                                  N'+63' ,
                                  N'菲律宾'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Philippines' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'ph' ,
                                [DialingCodes] = N'+63' ,
                                [ChineseName] = N'菲律宾'
                        WHERE   [CountryCode] = N'ph'


-- [CountryCode]=N'pk' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'pk' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'pk' ,
                                  N'Pakistan' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'me' ,
                                  N'or' ,
                                  N'pk' ,
                                  N'+92' ,
                                  N'巴基斯坦'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Pakistan' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'pk' ,
                                [DialingCodes] = N'+92' ,
                                [ChineseName] = N'巴基斯坦'
                        WHERE   [CountryCode] = N'pk'


-- [CountryCode]=N'pl' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'pl' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'pl' ,
                                  N'Poland' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'pl' ,
                                  N'+48' ,
                                  N'波兰'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Poland' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'pl' ,
                                [DialingCodes] = N'+48' ,
                                [ChineseName] = N'波兰'
                        WHERE   [CountryCode] = N'pl'


-- [CountryCode]=N'pm' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'pm' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'pm' ,
                                  N'St. Pierre' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'pm' ,
                                  N'+508' ,
                                  N'哈佛圣皮埃尔'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'St. Pierre' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'pm' ,
                                [DialingCodes] = N'+508' ,
                                [ChineseName] = N'哈佛圣皮埃尔'
                        WHERE   [CountryCode] = N'pm'


-- [CountryCode]=N'pr' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'pr' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'pr' ,
                                  N'Puerto Rico' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'pr' ,
                                  N'+1 787, +1 939' ,
                                  N'波多黎各'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Puerto Rico' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'pr' ,
                                [DialingCodes] = N'+1 787, +1 939' ,
                                [ChineseName] = N'波多黎各'
                        WHERE   [CountryCode] = N'pr'


-- [CountryCode]=N'ps' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ps' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ps' ,
                                  N'Palestine' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'ps' ,
                                  NULL ,
                                  N'巴勒斯坦'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Palestine' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'ps' ,
                                [DialingCodes] = NULL ,
                                [ChineseName] = N'巴勒斯坦'
                        WHERE   [CountryCode] = N'ps'


-- [CountryCode]=N'pt' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'pt' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'pt' ,
                                  N'Portugal' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'pt' ,
                                  N'+351' ,
                                  N'葡萄牙'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Portugal' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'pt' ,
                                [DialingCodes] = N'+351' ,
                                [ChineseName] = N'葡萄牙'
                        WHERE   [CountryCode] = N'pt'


-- [CountryCode]=N'pw' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'pw' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'pw' ,
                                  N'Palau' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'pw' ,
                                  N'+680' ,
                                  N'帕劳共和国'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Palau' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'pw' ,
                                [DialingCodes] = N'+680' ,
                                [ChineseName] = N'帕劳共和国'
                        WHERE   [CountryCode] = N'pw'


-- [CountryCode]=N'py' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'py' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'py' ,
                                  N'Paraguay' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'py' ,
                                  N'+595' ,
                                  N'巴拉圭'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Paraguay' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'py' ,
                                [DialingCodes] = N'+595' ,
                                [ChineseName] = N'巴拉圭'
                        WHERE   [CountryCode] = N'py'


-- [CountryCode]=N'qa' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'qa' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'qa' ,
                                  N'Qatar' ,
                                  N'USD' ,
                                  N'ar' ,
                                  N'me' ,
                                  N'or' ,
                                  N'qa' ,
                                  N'+974' ,
                                  N'卡塔尔'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Qatar' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'ar' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'qa' ,
                                [DialingCodes] = N'+974' ,
                                [ChineseName] = N'卡塔尔'
                        WHERE   [CountryCode] = N'qa'


-- [CountryCode]=N'qm' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'qm' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'qm' ,
                                  N'Kosovo' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'qm' ,
                                  NULL ,
                                  N'科索沃'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Kosovo' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'qm' ,
                                [DialingCodes] = NULL ,
                                [ChineseName] = N'科索沃'
                        WHERE   [CountryCode] = N'qm'


-- [CountryCode]=N'qn' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'qn' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'qn' ,
                                  N'Abkhazia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'qn' ,
                                  NULL ,
                                  N'阿布哈兹'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Abkhazia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'qn' ,
                                [DialingCodes] = NULL ,
                                [ChineseName] = N'阿布哈兹'
                        WHERE   [CountryCode] = N'qn'


-- [CountryCode]=N'qo' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'qo' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'qo' ,
                                  N'Narno-Karabakh Republic' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'qo' ,
                                  NULL ,
                                  N'纳戈尔诺-卡拉巴赫共和国'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Narno-Karabakh Republic' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'qo' ,
                                [DialingCodes] = NULL ,
                                [ChineseName] = N'纳戈尔诺-卡拉巴赫共和国'
                        WHERE   [CountryCode] = N'qo'


-- [CountryCode]=N'qp' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'qp' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'qp' ,
                                  N'Northern Cyprus' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'qp' ,
                                  NULL ,
                                  N'北賽普勒斯'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Northern Cyprus' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'qp' ,
                                [DialingCodes] = NULL ,
                                [ChineseName] = N'北賽普勒斯'
                        WHERE   [CountryCode] = N'qp'


-- [CountryCode]=N'qr' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'qr' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'qr' ,
                                  N'Sahrawi Arab Democratic Republic' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'qr' ,
                                  NULL ,
                                  N'阿拉伯撒哈拉民主共和国'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Sahrawi Arab Democratic Republic' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'qr' ,
                                [DialingCodes] = NULL ,
                                [ChineseName] = N'阿拉伯撒哈拉民主共和国'
                        WHERE   [CountryCode] = N'qr'


-- [CountryCode]=N'qs' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'qs' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'qs' ,
                                  N'Somaliland' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'qs' ,
                                  NULL ,
                                  N'索马里兰'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Somaliland' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'qs' ,
                                [DialingCodes] = NULL ,
                                [ChineseName] = N'索马里兰'
                        WHERE   [CountryCode] = N'qs'


-- [CountryCode]=N'qt' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'qt' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'qt' ,
                                  N'South Ossetia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'qt' ,
                                  NULL ,
                                  N'南奥塞梯'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'South Ossetia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'qt' ,
                                [DialingCodes] = NULL ,
                                [ChineseName] = N'南奥塞梯'
                        WHERE   [CountryCode] = N'qt'


-- [CountryCode]=N'qu' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'qu' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'qu' ,
                                  N'Transnistria' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'qu' ,
                                  NULL ,
                                  N'外涅斯特里亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Transnistria' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'qu' ,
                                [DialingCodes] = NULL ,
                                [ChineseName] = N'外涅斯特里亚'
                        WHERE   [CountryCode] = N'qu'


-- [CountryCode]=N'ro' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ro' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ro' ,
                                  N'Romania' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'ro' ,
                                  N'+40' ,
                                  N'罗马尼亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Romania' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'ro' ,
                                [DialingCodes] = N'+40' ,
                                [ChineseName] = N'罗马尼亚'
                        WHERE   [CountryCode] = N'ro'


-- [CountryCode]=N'rs' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'rs' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'rs' ,
                                  N'Serbia' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'rs' ,
                                  NULL ,
                                  N'塞尔维亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Serbia' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'rs' ,
                                [DialingCodes] = NULL ,
                                [ChineseName] = N'塞尔维亚'
                        WHERE   [CountryCode] = N'rs'


-- [CountryCode]=N'ru' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ru' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ru' ,
                                  N'Russia' ,
                                  N'EUR' ,
                                  N'ru' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'ru' ,
                                  N'+7' ,
                                  N'俄罗斯联邦'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Russia' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'ru' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'ru' ,
                                [DialingCodes] = N'+7' ,
                                [ChineseName] = N'俄罗斯联邦'
                        WHERE   [CountryCode] = N'ru'


-- [CountryCode]=N'rw' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'rw' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'rw' ,
                                  N'Rwanda' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'rw' ,
                                  N'+250' ,
                                  N'卢旺达'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Rwanda' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'rw' ,
                                [DialingCodes] = N'+250' ,
                                [ChineseName] = N'卢旺达'
                        WHERE   [CountryCode] = N'rw'


-- [CountryCode]=N'sa' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'sa' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'sa' ,
                                  N'Saudi Arabia' ,
                                  N'USD' ,
                                  N'ar' ,
                                  N'me' ,
                                  N'aa' ,
                                  N'sa' ,
                                  N'+966' ,
                                  N'沙特阿拉伯'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Saudi Arabia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'ar' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'sa' ,
                                [DialingCodes] = N'+966' ,
                                [ChineseName] = N'沙特阿拉伯'
                        WHERE   [CountryCode] = N'sa'


-- [CountryCode]=N'sb' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'sb' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'sb' ,
                                  N'Solomon Islands' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'sb' ,
                                  N'+677' ,
                                  N'所罗门群岛'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Solomon Islands' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'sb' ,
                                [DialingCodes] = N'+677' ,
                                [ChineseName] = N'所罗门群岛'
                        WHERE   [CountryCode] = N'sb'


-- [CountryCode]=N'sc' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'sc' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'sc' ,
                                  N'Seychelles' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'sc' ,
                                  N'+248' ,
                                  N'塞舌尔'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Seychelles' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'sc' ,
                                [DialingCodes] = N'+248' ,
                                [ChineseName] = N'塞舌尔'
                        WHERE   [CountryCode] = N'sc'


-- [CountryCode]=N'sd' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'sd' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'sd' ,
                                  N'Sudan' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'sd' ,
                                  N'+249' ,
                                  N'苏丹'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Sudan' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'sd' ,
                                [DialingCodes] = N'+249' ,
                                [ChineseName] = N'苏丹'
                        WHERE   [CountryCode] = N'sd'


-- [CountryCode]=N'se' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'se' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'se' ,
                                  N'Sweden' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'se' ,
                                  N'+46' ,
                                  N'瑞典'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Sweden' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'se' ,
                                [DialingCodes] = N'+46' ,
                                [ChineseName] = N'瑞典'
                        WHERE   [CountryCode] = N'se'


-- [CountryCode]=N'sg' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'sg' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'sg' ,
                                  N'Singapore' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'sg' ,
                                  N'+65' ,
                                  N'新加坡'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Singapore' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'sg' ,
                                [DialingCodes] = N'+65' ,
                                [ChineseName] = N'新加坡'
                        WHERE   [CountryCode] = N'sg'


-- [CountryCode]=N'sh' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'sh' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'sh' ,
                                  N'St. Helena' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'sh' ,
                                  N'+290' ,
                                  N'圣赫勒拿'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'St. Helena' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'sh' ,
                                [DialingCodes] = N'+290' ,
                                [ChineseName] = N'圣赫勒拿'
                        WHERE   [CountryCode] = N'sh'


-- [CountryCode]=N'si' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'si' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'si' ,
                                  N'Slovenia' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'si' ,
                                  N'+386' ,
                                  N'斯洛文尼亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Slovenia' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'si' ,
                                [DialingCodes] = N'+386' ,
                                [ChineseName] = N'斯洛文尼亚'
                        WHERE   [CountryCode] = N'si'


-- [CountryCode]=N'sj' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'sj' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'sj' ,
                                  N'Svalbard' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'sj' ,
                                  N'+47' ,
                                  N'斯瓦尔巴特群岛'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Svalbard' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'sj' ,
                                [DialingCodes] = N'+47' ,
                                [ChineseName] = N'斯瓦尔巴特群岛'
                        WHERE   [CountryCode] = N'sj'


-- [CountryCode]=N'sk' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'sk' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'sk' ,
                                  N'Slovakia' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'sk' ,
                                  N'+421' ,
                                  N'斯洛伐克'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Slovakia' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'sk' ,
                                [DialingCodes] = N'+421' ,
                                [ChineseName] = N'斯洛伐克'
                        WHERE   [CountryCode] = N'sk'


-- [CountryCode]=N'sl' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'sl' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'sl' ,
                                  N'Sierra Leone' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'sl' ,
                                  N'+232' ,
                                  N'塞拉利昂'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Sierra Leone' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'sl' ,
                                [DialingCodes] = N'+232' ,
                                [ChineseName] = N'塞拉利昂'
                        WHERE   [CountryCode] = N'sl'


-- [CountryCode]=N'sm' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'sm' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'sm' ,
                                  N'San Marino' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'sm' ,
                                  N'+378' ,
                                  N'圣马力诺'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'San Marino' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'sm' ,
                                [DialingCodes] = N'+378' ,
                                [ChineseName] = N'圣马力诺'
                        WHERE   [CountryCode] = N'sm'


-- [CountryCode]=N'sn' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'sn' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'sn' ,
                                  N'Senegal' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'sn' ,
                                  N'+221' ,
                                  N'塞内加尔'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Senegal' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'sn' ,
                                [DialingCodes] = N'+221' ,
                                [ChineseName] = N'塞内加尔'
                        WHERE   [CountryCode] = N'sn'


-- [CountryCode]=N'so' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'so' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'so' ,
                                  N'Somalia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'so' ,
                                  N'+252' ,
                                  N'索马里'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Somalia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'so' ,
                                [DialingCodes] = N'+252' ,
                                [ChineseName] = N'索马里'
                        WHERE   [CountryCode] = N'so'


-- [CountryCode]=N'sr' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'sr' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'sr' ,
                                  N'Suriname' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'sr' ,
                                  N'+597' ,
                                  N'苏里南'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Suriname' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'sr' ,
                                [DialingCodes] = N'+597' ,
                                [ChineseName] = N'苏里南'
                        WHERE   [CountryCode] = N'sr'


-- [CountryCode]=N'st' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'st' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'st' ,
                                  N'Sao Tome' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'st' ,
                                  N'+239' ,
                                  NULL
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Sao Tome' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'st' ,
                                [DialingCodes] = N'+239' ,
                                [ChineseName] = NULL
                        WHERE   [CountryCode] = N'st'


-- [CountryCode]=N'sv' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'sv' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'sv' ,
                                  N'El Salvador' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'sv' ,
                                  N'+503' ,
                                  N'萨尔瓦多'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'El Salvador' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'sv' ,
                                [DialingCodes] = N'+503' ,
                                [ChineseName] = N'萨尔瓦多'
                        WHERE   [CountryCode] = N'sv'


-- [CountryCode]=N'sy' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'sy' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'sy' ,
                                  N'Syria' ,
                                  N'USD' ,
                                  N'ar' ,
                                  N'me' ,
                                  N'or' ,
                                  N'sy' ,
                                  N'+963' ,
                                  NULL
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Syria' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'ar' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'sy' ,
                                [DialingCodes] = N'+963' ,
                                [ChineseName] = NULL
                        WHERE   [CountryCode] = N'sy'


-- [CountryCode]=N'sz' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'sz' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'sz' ,
                                  N'Swaziland' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'sz' ,
                                  N'+268' ,
                                  N'斯威士兰'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Swaziland' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'sz' ,
                                [DialingCodes] = N'+268' ,
                                [ChineseName] = N'斯威士兰'
                        WHERE   [CountryCode] = N'sz'


-- [CountryCode]=N'td' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'td' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'td' ,
                                  N'Chad' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'td' ,
                                  N'+235' ,
                                  N'乍得'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Chad' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'td' ,
                                [DialingCodes] = N'+235' ,
                                [ChineseName] = N'乍得'
                        WHERE   [CountryCode] = N'td'


-- [CountryCode]=N'tg' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'tg' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'tg' ,
                                  N'To' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'tg' ,
                                  N'+228' ,
                                  N'多哥'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'To' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'tg' ,
                                [DialingCodes] = N'+228' ,
                                [ChineseName] = N'多哥'
                        WHERE   [CountryCode] = N'tg'


-- [CountryCode]=N'th' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'th' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'th' ,
                                  N'Thailand' ,
                                  N'THB' ,
                                  N'th' ,
                                  N'th' ,
                                  N'aa' ,
                                  N'th' ,
                                  N'+66' ,
                                  N'泰国'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Thailand' ,
                                [Currency] = N'THB' ,
                                [DefaultLanguage] = N'th' ,
                                [Region] = N'th' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'th' ,
                                [DialingCodes] = N'+66' ,
                                [ChineseName] = N'泰国'
                        WHERE   [CountryCode] = N'th'


-- [CountryCode]=N'tj' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'tj' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'tj' ,
                                  N'Tajikistan' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'me' ,
                                  N'aa' ,
                                  N'tj' ,
                                  N'+992' ,
                                  NULL
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Tajikistan' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'tj' ,
                                [DialingCodes] = N'+992' ,
                                [ChineseName] = NULL
                        WHERE   [CountryCode] = N'tj'


-- [CountryCode]=N'tk' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'tk' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'tk' ,
                                  N'Tokelau' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'tk' ,
                                  N'+690' ,
                                  NULL
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Tokelau' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'tk' ,
                                [DialingCodes] = N'+690' ,
                                [ChineseName] = NULL
                        WHERE   [CountryCode] = N'tk'


-- [CountryCode]=N'tm' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'tm' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'tm' ,
                                  N'Turkmenistan' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'me' ,
                                  N'aa' ,
                                  N'tm' ,
                                  N'+993' ,
                                  N'土库曼斯坦'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Turkmenistan' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'tm' ,
                                [DialingCodes] = N'+993' ,
                                [ChineseName] = N'土库曼斯坦'
                        WHERE   [CountryCode] = N'tm'


-- [CountryCode]=N'tn' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'tn' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'tn' ,
                                  N'Tunisia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'tn' ,
                                  N'+216' ,
                                  N'突尼斯'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Tunisia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'tn' ,
                                [DialingCodes] = N'+216' ,
                                [ChineseName] = N'突尼斯'
                        WHERE   [CountryCode] = N'tn'


-- [CountryCode]=N'to' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'to' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'to' ,
                                  N'Tonga' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'to' ,
                                  N'+676' ,
                                  N'汤加'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Tonga' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'to' ,
                                [DialingCodes] = N'+676' ,
                                [ChineseName] = N'汤加'
                        WHERE   [CountryCode] = N'to'


-- [CountryCode]=N'tp' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'tp' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'tp' ,
                                  N'East Timor' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'tp' ,
                                  N'+670' ,
                                  N'东帝汶'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'East Timor' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'tp' ,
                                [DialingCodes] = N'+670' ,
                                [ChineseName] = N'东帝汶'
                        WHERE   [CountryCode] = N'tp'


-- [CountryCode]=N'tr' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'tr' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'tr' ,
                                  N'Turkey' ,
                                  N'EUR' ,
                                  N'tr' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'tr' ,
                                  N'+90' ,
                                  N'土耳其'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Turkey' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'tr' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'tr' ,
                                [DialingCodes] = N'+90' ,
                                [ChineseName] = N'土耳其'
                        WHERE   [CountryCode] = N'tr'


-- [CountryCode]=N'tt' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'tt' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'tt' ,
                                  N'Trinidad and Toba' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'tt' ,
                                  N'+1 868' ,
                                  NULL
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Trinidad and Toba' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'tt' ,
                                [DialingCodes] = N'+1 868' ,
                                [ChineseName] = NULL
                        WHERE   [CountryCode] = N'tt'


-- [CountryCode]=N'tv' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'tv' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'tv' ,
                                  N'Tuvalu' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'tv' ,
                                  N'+688' ,
                                  N'图瓦卢'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Tuvalu' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'tv' ,
                                [DialingCodes] = N'+688' ,
                                [ChineseName] = N'图瓦卢'
                        WHERE   [CountryCode] = N'tv'


-- [CountryCode]=N'tw' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'tw' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'tw' ,
                                  N'Taiwan' ,
                                  N'TWD' ,
                                  N'ch' ,
                                  N'tw' ,
                                  N'tw' ,
                                  N'tw' ,
                                  N'+886' ,
                                  NULL
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Taiwan' ,
                                [Currency] = N'TWD' ,
                                [DefaultLanguage] = N'ch' ,
                                [Region] = N'tw' ,
                                [AccountingRegion] = N'tw' ,
                                [ISOLocaleCode] = N'tw' ,
                                [DialingCodes] = N'+886' ,
                                [ChineseName] = NULL
                        WHERE   [CountryCode] = N'tw'


-- [CountryCode]=N'tz' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'tz' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'tz' ,
                                  N'Tanzania' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'tz' ,
                                  N'+255' ,
                                  N'坦桑尼亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Tanzania' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'tz' ,
                                [DialingCodes] = N'+255' ,
                                [ChineseName] = N'坦桑尼亚'
                        WHERE   [CountryCode] = N'tz'


-- [CountryCode]=N'ua' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ua' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ua' ,
                                  N'Ukraine' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'ua' ,
                                  N'+380' ,
                                  N'乌克兰'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Ukraine' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'ua' ,
                                [DialingCodes] = N'+380' ,
                                [ChineseName] = N'乌克兰'
                        WHERE   [CountryCode] = N'ua'


-- [CountryCode]=N'ug' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ug' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ug' ,
                                  N'Uganda' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'ug' ,
                                  N'+256' ,
                                  N'乌干达'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Uganda' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'ug' ,
                                [DialingCodes] = N'+256' ,
                                [ChineseName] = N'乌干达'
                        WHERE   [CountryCode] = N'ug'


-- [CountryCode]=N'uk' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'uk' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'uk' ,
                                  N'United Kingdom' ,
                                  N'EUR' ,
                                  N'en' ,
                                  N'eu' ,
                                  N'uf' ,
                                  N'uk' ,
                                  NULL ,
                                  N'英国'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'United Kingdom' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'uf' ,
                                [ISOLocaleCode] = N'uk' ,
                                [DialingCodes] = NULL ,
                                [ChineseName] = N'英国'
                        WHERE   [CountryCode] = N'uk'


-- [CountryCode]=N'us' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'us' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'us' ,
                                  N'United States' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'us' ,
                                  N'or' ,
                                  N'us' ,
                                  N'+1' ,
                                  N'美国'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'United States' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'us' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'us' ,
                                [DialingCodes] = N'+1' ,
                                [ChineseName] = N'美国'
                        WHERE   [CountryCode] = N'us'


-- [CountryCode]=N'uy' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'uy' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'uy' ,
                                  N'Uruguay' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'uy' ,
                                  N'+598' ,
                                  N'乌拉圭'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Uruguay' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'uy' ,
                                [DialingCodes] = N'+598' ,
                                [ChineseName] = N'乌拉圭'
                        WHERE   [CountryCode] = N'uy'


-- [CountryCode]=N'uz' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'uz' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'uz' ,
                                  N'Uzbekistan' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'me' ,
                                  N'aa' ,
                                  N'uz' ,
                                  N'+998' ,
                                  NULL
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Uzbekistan' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'uz' ,
                                [DialingCodes] = N'+998' ,
                                [ChineseName] = NULL
                        WHERE   [CountryCode] = N'uz'


-- [CountryCode]=N'va' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'va' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'va' ,
                                  N'Vatican' ,
                                  N'EUR' ,
                                  N'it' ,
                                  N'eu' ,
                                  N'eu' ,
                                  N'va' ,
                                  N'+379' ,
                                  NULL
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Vatican' ,
                                [Currency] = N'EUR' ,
                                [DefaultLanguage] = N'it' ,
                                [Region] = N'eu' ,
                                [AccountingRegion] = N'eu' ,
                                [ISOLocaleCode] = N'va' ,
                                [DialingCodes] = N'+379' ,
                                [ChineseName] = NULL
                        WHERE   [CountryCode] = N'va'


-- [CountryCode]=N'vc' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'vc' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'vc' ,
                                  N'Saint Vincent' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'vc' ,
                                  N'+1 784' ,
                                  NULL
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Saint Vincent' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'vc' ,
                                [DialingCodes] = N'+1 784' ,
                                [ChineseName] = NULL
                        WHERE   [CountryCode] = N'vc'


-- [CountryCode]=N've' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N've' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N've' ,
                                  N'Venezuela' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N've' ,
                                  NULL ,
                                  N'委内瑞拉'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Venezuela' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N've' ,
                                [DialingCodes] = NULL ,
                                [ChineseName] = N'委内瑞拉'
                        WHERE   [CountryCode] = N've'


-- [CountryCode]=N'vg' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'vg' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'vg' ,
                                  N'Virgin Islands (UK)' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'vg' ,
                                  N'+1 284' ,
                                  NULL
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Virgin Islands (UK)' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'vg' ,
                                [DialingCodes] = N'+1 284' ,
                                [ChineseName] = NULL
                        WHERE   [CountryCode] = N'vg'


-- [CountryCode]=N'vi' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'vi' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'vi' ,
                                  N'Virgin Islands (US)' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'vi' ,
                                  N'+1 340' ,
                                  NULL
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Virgin Islands (US)' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'vi' ,
                                [DialingCodes] = N'+1 340' ,
                                [ChineseName] = NULL
                        WHERE   [CountryCode] = N'vi'


-- [CountryCode]=N'vn' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'vn' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'vn' ,
                                  N'Vietnam' ,
                                  N'USD' ,
                                  N'vi' ,
                                  N'aa' ,
                                  N'aa' ,
                                  N'vn' ,
                                  N'+84' ,
                                  N'越南'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Vietnam' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'vi' ,
                                [Region] = N'aa' ,
                                [AccountingRegion] = N'aa' ,
                                [ISOLocaleCode] = N'vn' ,
                                [DialingCodes] = N'+84' ,
                                [ChineseName] = N'越南'
                        WHERE   [CountryCode] = N'vn'


-- [CountryCode]=N'vu' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'vu' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'vu' ,
                                  N'Vanuatu' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'vu' ,
                                  N'+678' ,
                                  N'瓦努阿图'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Vanuatu' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'vu' ,
                                [DialingCodes] = N'+678' ,
                                [ChineseName] = N'瓦努阿图'
                        WHERE   [CountryCode] = N'vu'


-- [CountryCode]=N'vz' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'vz' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'vz' ,
                                  N'Venezuela' ,
                                  N'USD' ,
                                  N'sp' ,
                                  N'ln' ,
                                  N'ln' ,
                                  N'vz' ,
                                  N'+58' ,
                                  N'委内瑞拉'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Venezuela' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'sp' ,
                                [Region] = N'ln' ,
                                [AccountingRegion] = N'ln' ,
                                [ISOLocaleCode] = N'vz' ,
                                [DialingCodes] = N'+58' ,
                                [ChineseName] = N'委内瑞拉'
                        WHERE   [CountryCode] = N'vz'


-- [CountryCode]=N'ws' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ws' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ws' ,
                                  N'Samoa' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'ws' ,
                                  N'+685' ,
                                  N'萨摩亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Samoa' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'ws' ,
                                [DialingCodes] = N'+685' ,
                                [ChineseName] = N'萨摩亚'
                        WHERE   [CountryCode] = N'ws'


-- [CountryCode]=N'ye' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'ye' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'ye' ,
                                  N'Yemen' ,
                                  N'USD' ,
                                  N'ar' ,
                                  N'me' ,
                                  N'or' ,
                                  N'ye' ,
                                  N'+967' ,
                                  NULL
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Yemen' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'ar' ,
                                [Region] = N'me' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'ye' ,
                                [DialingCodes] = N'+967' ,
                                [ChineseName] = NULL
                        WHERE   [CountryCode] = N'ye'


-- [CountryCode]=N'za' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'za' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'za' ,
                                  N'South Africa' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'za' ,
                                  N'+27' ,
                                  NULL
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'South Africa' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'za' ,
                                [DialingCodes] = N'+27' ,
                                [ChineseName] = NULL
                        WHERE   [CountryCode] = N'za'


-- [CountryCode]=N'zm' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'zm' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'zm' ,
                                  N'Zambia' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'zm' ,
                                  N'+260' ,
                                  N'赞比亚'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Zambia' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'zm' ,
                                [DialingCodes] = N'+260' ,
                                [ChineseName] = N'赞比亚'
                        WHERE   [CountryCode] = N'zm'


-- [CountryCode]=N'zw' ---------------------------------
                    IF NOT EXISTS ( SELECT  *
                                    FROM    dbo.Country
                                    WHERE   [CountryCode] = N'zw' ) 
                        INSERT  INTO dbo.Country
                                ( [CountryCode] ,
                                  [CountryName] ,
                                  [Currency] ,
                                  [DefaultLanguage] ,
                                  [Region] ,
                                  [AccountingRegion] ,
                                  [ISOLocaleCode] ,
                                  [DialingCodes] ,
                                  [ChineseName]
                                )
                        VALUES  ( N'zw' ,
                                  N'Zimbabwe' ,
                                  N'USD' ,
                                  N'en' ,
                                  N'or' ,
                                  N'or' ,
                                  N'zw' ,
                                  N'+263' ,
                                  N'津巴布韦'
                                )
                    ELSE 
                        UPDATE  dbo.Country
                        SET     [CountryName] = N'Zimbabwe' ,
                                [Currency] = N'USD' ,
                                [DefaultLanguage] = N'en' ,
                                [Region] = N'or' ,
                                [AccountingRegion] = N'or' ,
                                [ISOLocaleCode] = N'zw' ,
                                [DialingCodes] = N'+263' ,
                                [ChineseName] = N'津巴布韦'
                        WHERE   [CountryCode] = N'zw'


                END
            COMMIT ;
        END TRY
        BEGIN CATCH
            ROLLBACK ;
        END CATCH
    END